app/src/main/java/ai/pai/lensman/db/DBService.java

@@ -227,9 +227,10 @@ public class DBService {

                             try {
              

                                 db = dbHelper.getReadableDatabase();
              

                                 db.beginTransaction();
              

                +                long time = (System.currentTimeMillis()-30_1000);
              

                                 c = db.rawQuery("select * from " + DBHelper.PHOTO_INFO_TABLE +  " where "
              

                                         + DBHelper.PHOTO_INFO_COLUMNS.UPLOADED_STATUS + " = '" + 0 + "'"
              

                -                        +" and "+DBHelper.PHOTO_INFO_COLUMNS.CAPTURE_TIME+" <" +"'"+(System.currentTimeMillis()-30_1000)
              

                +                        +" and "+DBHelper.PHOTO_INFO_COLUMNS.CAPTURE_TIME+" <" +"'"+time
              

                                         +"'  order by "
              

                                         + DBHelper.PHOTO_INFO_COLUMNS.CAPTURE_TIME + " desc limit 1 ", null);
              

                                 if (c.moveToNext()) {